package com.jiyun.mapper;

import com.jiyun.pojo.vo.OrderVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface OrderMapperVo extends Mapper<OrderVo> {
    @Select("select * from `order` AS o,`status` AS s where  o.statusid=s.statusid and o.userid=#{userid}")
    List<OrderVo> findAllPutongOrder(Integer userid);
    @Select("select * from `order` AS o,`status` AS s where  o.statusid=s.statusid and o.userid=#{userid} and o.statusid=#{seid}")
    List<OrderVo> selectstatus(@Param("userid") Integer userid, @Param("seid") Integer seid);
}
